import numpy as np
import pandas as pd
import xlrd
import matplotlib.pyplot as plt

df = pd.read_excel('d:/dataset/全国受教育程度情况.xls', header=1)
df1 = df.iloc[0:12:3]

data1  = df1.sort_values(by='招生数',ascending=False)
data = list(data1['招生数'])
label = list(data1['项目'])
